SheetName

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

ApplyValidation_DropDown

Adds Validation drop-down to a cell (Data --> Validation --> List), or to a ...

SheetDelete_ANmar

Deletes a sheet from a workbook, checks it is already there first

Sheets to PDF pages

Export multiple sheets as pages in 1 pdf, doc, still rough and not elegant as ...

WelcomeSheet

A User-Friendly way to ask user to enable macros. Showing an only sheet to let ...

WelcomeSheet.zip

XLThumbView

Showing thumbnails inside sheet and enlarging each when click

XLThumbview.zip

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

SettingRead_JR

Reads setting saved in columns J:R Just like SettingRead, but when we have ...

CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

CellHyperlink_ToSheet

Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...

CellRead

Reads a value giving column, row, sheet and workbook name Accepts up to 2 ...